SELECT 'SBD' = EmployeeID, 'HoTen' = SurName + ' ' + Name,
'KhoiThi' = 'A', 'MaNganh' = DivisionID, 'NgaySinh' = BirthDay,
'DM1' = ABS(CAST(NEWID() AS binary(6)) %11), 'DM2' = ABS(CAST(NEWID() AS binary(6)) %11), 'DM3' = ABS(CAST(NEWID() AS binary(6)) %11),
'MaTruong' = 'KT', 'Nam' = 2013
INTO KetQua
FROM [kimtruc2.no-ip.info].[kimtrucdata].[dbo].[Employee]